Profile Report for intermediate\member

Brought to you by YData

Dataset statistics

Number of variables	11
Number of observations	52793
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	9.6 MiB
Average record size in memory	190.7 B

Variable types

Numeric	8
Text	1
DateTime	1
Boolean	1

Alerts

`attacks` is highly overall correlated with `score`	High correlation
`days_since_first_war` is highly overall correlated with `war_id`	High correlation
`faction_id` is highly overall correlated with `member_level`	High correlation
`member_id` is highly overall correlated with `member_level`	High correlation
`member_level` is highly overall correlated with `faction_id` and 1 other fields	High correlation
`score` is highly overall correlated with `attacks`	High correlation
`war_id` is highly overall correlated with `days_since_first_war`	High correlation
`attacks` has 20094 (38.1%) zeros	Zeros
`score` has 20094 (38.1%) zeros	Zeros

Reproduction

Analysis started	2025-07-22 17:11:08.311805
Analysis finished	2025-07-22 17:11:17.628428
Duration	9.32 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

war_id
Real number (ℝ)

High correlation

Distinct	696
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23183.665

Minimum	18131
Maximum	28089
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	412.6 KiB

Quantile statistics

Minimum	18131
5-th percentile	18680
Q1	20811
median	23188
Q3	25710
95-th percentile	27612
Maximum	28089
Range	9958
Interquartile range (IQR)	4899

Descriptive statistics

Standard deviation	2884.1246
Coefficient of variation (CV)	0.12440331
Kurtosis	-1.2242648
Mean	23183.665
Median Absolute Deviation (MAD)	2404
Skewness	-0.026840762
Sum	1.2239352 × 10⁹
Variance	8318174.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27742	200	0.4%
23798	200	0.4%
19304	200	0.4%
25852	200	0.4%
27455	199	0.4%
19557	199	0.4%
27141	199	0.4%
20811	199	0.4%
24583	198	0.4%
18680	198	0.4%
Other values (686)	50801	96.2%

Value	Count	Frequency (%)
18131	25	< 0.1%
18134	40	0.1%
18155	24	< 0.1%
18178	190	0.4%
18189	47	0.1%
18214	27	0.1%
18215	30	0.1%
18242	195	0.4%
18247	170	0.3%
18248	31	0.1%

Value	Count	Frequency (%)
28089	47	0.1%
28084	34	0.1%
28068	34	0.1%
28058	36	0.1%
28052	113	0.2%
28051	26	< 0.1%
28015	197	0.4%
28013	197	0.4%
28006	27	0.1%
27981	59	0.1%

faction_id
Real number (ℝ)

High correlation

Distinct	822
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29746.143

Minimum	89
Maximum	54339
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	412.6 KiB

Quantile statistics

Minimum	89
5-th percentile	7002
Q1	11428
median	29865
Q3	48640
95-th percentile	52775
Maximum	54339
Range	54250
Interquartile range (IQR)	37212

Descriptive statistics

Standard deviation	17754.54
Coefficient of variation (CV)	0.59686864
Kurtosis	-1.5907719
Mean	29746.143
Median Absolute Deviation (MAD)	18596
Skewness	-0.043645567
Sum	1.5703881 × 10⁹
Variance	3.152237 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
937	691	1.3%
21368	594	1.1%
7835	552	1.0%
23952	456	0.9%
14821	431	0.8%
8422	394	0.7%
8706	391	0.7%
21665	387	0.7%
8537	383	0.7%
8085	382	0.7%
Other values (812)	48132	91.2%

Value	Count	Frequency (%)
89	100	0.2%
230	75	0.1%
231	275	0.5%
366	296	0.6%
478	84	0.2%
525	93	0.2%
937	691	1.3%
1117	52	0.1%
1251	18	< 0.1%
2095	57	0.1%

Value	Count	Frequency (%)
54339	15	< 0.1%
54260	14	< 0.1%
54250	19	< 0.1%
54249	10	< 0.1%
54245	15	< 0.1%
54226	12	< 0.1%
54214	28	0.1%
54212	14	< 0.1%
54200	15	< 0.1%
54197	12	< 0.1%

member_id
Real number (ℝ)

High correlation

Distinct	31556
Distinct (%)	59.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2606864

Minimum	5
Maximum	3869385
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	412.6 KiB

Quantile statistics

Minimum	5
5-th percentile	521780.2
Q1	2160927
median	2794601
Q3	3304693
95-th percentile	3646737
Maximum	3869385
Range	3869380
Interquartile range (IQR)	1143766

Descriptive statistics

Standard deviation	895811.03
Coefficient of variation (CV)	0.3436355
Kurtosis	0.62039519
Mean	2606864
Median Absolute Deviation (MAD)	562610
Skewness	-1.0772077
Sum	1.3762417 × 10¹¹
Variance	8.0247739 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2663371	7	< 0.1%
2928469	7	< 0.1%
1673083	7	< 0.1%
2520389	7	< 0.1%
225661	7	< 0.1%
1688185	7	< 0.1%
137261	7	< 0.1%
1288184	7	< 0.1%
2415291	7	< 0.1%
2361923	7	< 0.1%
Other values (31546)	52723	99.9%

Value	Count	Frequency (%)
5	2	< 0.1%
37	3	< 0.1%
56	2	< 0.1%
89	3	< 0.1%
96	1	< 0.1%
145	2	< 0.1%
193	1	< 0.1%
262	1	< 0.1%
286	4	< 0.1%
567	1	< 0.1%

Value	Count	Frequency (%)
3869385	1	< 0.1%
3867474	1	< 0.1%
3865415	1	< 0.1%
3861425	1	< 0.1%
3860687	1	< 0.1%
3856144	1	< 0.1%
3855794	1	< 0.1%
3853267	1	< 0.1%
3853136	1	< 0.1%
3852331	1	< 0.1%

member_name
Text

Distinct	31558
Distinct (%)	59.8%
Missing	0
Missing (%)	0.0%
Memory size	2.9 MiB

Length

Max length	15
Median length	11
Mean length	8.6578713
Min length	3

Characters and Unicode

Total characters	457075
Distinct characters	64
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18715 ?
Unique (%)	35.4%

Sample

1st row	ValascaS
2nd row	Tom--
3rd row	Schnitzel
4th row	Volny
5th row	Travis-

Value	Count	Frequency (%)
pendragon	10	< 0.1%
lsd	10	< 0.1%
john	9	< 0.1%
deadpool	8	< 0.1%
johnny000	7	< 0.1%
breez	7	< 0.1%
vilmis	7	< 0.1%
neimles	7	< 0.1%
ledoksnis	7	< 0.1%
vecs	7	< 0.1%
Other values (31437)	52714	99.9%

Most occurring characters

Value	Count	Frequency (%)
e	37428	8.2%
a	36670	8.0%
i	27106	5.9%
o	27002	5.9%
r	25919	5.7%
n	23993	5.2%
l	18396	4.0%
t	17282	3.8%
s	16827	3.7%
u	11936	2.6%
Other values (54)	214516	46.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	457075	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	37428	8.2%
a	36670	8.0%
i	27106	5.9%
o	27002	5.9%
r	25919	5.7%
n	23993	5.2%
l	18396	4.0%
t	17282	3.8%
s	16827	3.7%
u	11936	2.6%
Other values (54)	214516	46.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	457075	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	37428	8.2%
a	36670	8.0%
i	27106	5.9%
o	27002	5.9%
r	25919	5.7%
n	23993	5.2%
l	18396	4.0%
t	17282	3.8%
s	16827	3.7%
u	11936	2.6%
Other values (54)	214516	46.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	457075	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	37428	8.2%
a	36670	8.0%
i	27106	5.9%
o	27002	5.9%
r	25919	5.7%
n	23993	5.2%
l	18396	4.0%
t	17282	3.8%
s	16827	3.7%
u	11936	2.6%
Other values (54)	214516	46.9%

member_level
Real number (ℝ)

High correlation

Distinct	100
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	57.191237

Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	412.6 KiB

Quantile statistics

Minimum	1
5-th percentile	15
Q1	30
median	52
Q3	90
95-th percentile	100
Maximum	100
Range	99
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	30.809628
Coefficient of variation (CV)	0.53871238
Kurtosis	-1.4125145
Mean	57.191237
Median Absolute Deviation (MAD)	28
Skewness	0.090472782
Sum	3019297
Variance	949.23317
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	8377	15.9%
50	1470	2.8%
20	1234	2.3%
40	1226	2.3%
30	1106	2.1%
15	1059	2.0%
25	1047	2.0%
35	971	1.8%
99	944	1.8%
60	877	1.7%
Other values (90)	34482	65.3%

Value	Count	Frequency (%)
1	85	0.2%
2	46	0.1%
3	146	0.3%
4	136	0.3%
5	144	0.3%
6	174	0.3%
7	174	0.3%
8	174	0.3%
9	257	0.5%
10	277	0.5%

Value	Count	Frequency (%)
100	8377	15.9%
99	944	1.8%
98	374	0.7%
97	351	0.7%
96	418	0.8%
95	531	1.0%
94	388	0.7%
93	409	0.8%
92	438	0.8%
91	412	0.8%

war_start_time
Date

Distinct	541
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	412.6 KiB

Minimum	2024-09-27 02:00:00
Maximum	2025-07-19 18:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

war_duration_hours
Real number (ℝ)

Distinct	548
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.271756

Minimum	3.13
Maximum	116.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	412.6 KiB

Quantile statistics

Minimum	3.13
5-th percentile	7.64
Q1	22.67
median	48.36
Q3	80.02
95-th percentile	104.02
Maximum	116.02
Range	112.89
Interquartile range (IQR)	57.35

Descriptive statistics

Standard deviation	31.937866
Coefficient of variation (CV)	0.62291345
Kurtosis	-1.1698968
Mean	51.271756
Median Absolute Deviation (MAD)	27.66
Skewness	0.26423067
Sum	2706789.8
Variance	1020.0273
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
95.02	855	1.6%
78.02	726	1.4%
91.02	697	1.3%
82.02	687	1.3%
100.02	574	1.1%
74.02	550	1.0%
58.02	514	1.0%
57.02	509	1.0%
101.02	505	1.0%
83.02	480	0.9%
Other values (538)	46696	88.5%

Value	Count	Frequency (%)
3.13	196	0.4%
4.33	179	0.3%
4.4	117	0.2%
4.71	174	0.3%
4.78	200	0.4%
4.82	176	0.3%
5.11	179	0.3%
6.02	97	0.2%
6.34	174	0.3%
6.52	399	0.8%

Value	Count	Frequency (%)
116.02	199	0.4%
115.61	34	0.1%
115.02	195	0.4%
113.02	192	0.4%
111.1	28	0.1%
111.02	163	0.3%
110.55	31	0.1%
110.02	28	0.1%
109.02	123	0.2%
108.13	40	0.1%

attacks
Real number (ℝ)

High correlation Zeros

Distinct	247
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.770898

Minimum	0
Maximum	408
Zeros	20094
Zeros (%)	38.1%
Negative	0
Negative (%)	0.0%
Memory size	412.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	21
95-th percentile	74
Maximum	408
Range	408
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	28.309344
Coefficient of variation (CV)	1.6880041
Kurtosis	12.833922
Mean	16.770898
Median Absolute Deviation (MAD)	4
Skewness	2.9801185
Sum	885386
Variance	801.41897
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	20094	38.1%
1	2211	4.2%
2	1491	2.8%
4	1368	2.6%
5	1304	2.5%
3	1298	2.5%
10	1241	2.4%
6	1142	2.2%
7	959	1.8%
8	952	1.8%
Other values (237)	20733	39.3%

Value	Count	Frequency (%)
0	20094	38.1%
1	2211	4.2%
2	1491	2.8%
3	1298	2.5%
4	1368	2.6%
5	1304	2.5%
6	1142	2.2%
7	959	1.8%
8	952	1.8%
9	873	1.7%

Value	Count	Frequency (%)
408	1	< 0.1%
389	1	< 0.1%
354	1	< 0.1%
319	1	< 0.1%
308	1	< 0.1%
299	1	< 0.1%
281	1	< 0.1%
276	1	< 0.1%
274	2	< 0.1%
271	1	< 0.1%

score
Real number (ℝ)

High correlation Zeros

Distinct	21774
Distinct (%)	41.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	124.63114

Minimum	0
Maximum	10501.69
Zeros	20094
Zeros (%)	38.1%
Negative	0
Negative (%)	0.0%
Memory size	412.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	28.32
Q3	151.83
95-th percentile	550.24
Maximum	10501.69
Range	10501.69
Interquartile range (IQR)	151.83

Descriptive statistics

Standard deviation	234.06994
Coefficient of variation (CV)	1.8781017
Kurtosis	101.09505
Mean	124.63114
Median Absolute Deviation (MAD)	28.32
Skewness	5.540738
Sum	6579651.6
Variance	54788.739
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	20094	38.1%
6.42	27	0.1%
6.6	24	< 0.1%
6.48	24	< 0.1%
6.24	19	< 0.1%
6.54	19	< 0.1%
10	17	< 0.1%
6.3	17	< 0.1%
6.18	16	< 0.1%
6.36	15	< 0.1%
Other values (21764)	32521	61.6%

Value	Count	Frequency (%)
0	20094	38.1%
1.92	1	< 0.1%
2.06	4	< 0.1%
2.08	3	< 0.1%
2.1	2	< 0.1%
2.12	3	< 0.1%
2.13	1	< 0.1%
2.14	2	< 0.1%
2.16	1	< 0.1%
2.18	3	< 0.1%

Value	Count	Frequency (%)
10501.69	1	< 0.1%
5012.31	1	< 0.1%
3856.93	1	< 0.1%
3663.08	1	< 0.1%
3638.85	1	< 0.1%
3557.97	1	< 0.1%
3551.33	1	< 0.1%
3442.22	1	< 0.1%
3411.96	1	< 0.1%
3292.45	1	< 0.1%

participated
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	51.7 KiB

True	32699
False	20094

Value	Count	Frequency (%)
True	32699	61.9%
False	20094	38.1%

days_since_first_war
Real number (ℝ)

High correlation

Distinct	131
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	162.38691

Minimum	0
Maximum	295
Zeros	89
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	412.6 KiB

Quantile statistics

Minimum	0
5-th percentile	20
Q1	105
median	168
Q3	237
95-th percentile	280
Maximum	295
Range	295
Interquartile range (IQR)	132

Descriptive statistics

Standard deviation	82.229034
Coefficient of variation (CV)	0.50637724
Kurtosis	-1.1006928
Mean	162.38691
Median Absolute Deviation (MAD)	64
Skewness	-0.22322969
Sum	8572892
Variance	6761.614
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
106	1678	3.2%
50	1587	3.0%
239	1285	2.4%
230	1114	2.1%
260	1046	2.0%
160	916	1.7%
195	891	1.7%
113	874	1.7%
105	869	1.6%
43	856	1.6%
Other values (121)	41677	78.9%

Value	Count	Frequency (%)
0	89	0.2%
6	434	0.8%
7	466	0.9%
8	692	1.3%
12	29	0.1%
13	298	0.6%
14	50	0.1%
15	399	0.8%
20	433	0.8%
21	346	0.7%

Value	Count	Frequency (%)
295	160	0.3%
294	94	0.2%
293	36	0.1%
288	450	0.9%
287	608	1.2%
286	607	1.1%
281	374	0.7%
280	844	1.6%
279	157	0.3%
274	604	1.1%

	attacks	days_since_first_war	faction_id	member_id	member_level	participated	score	war_duration_hours	war_id
attacks	1.000	-0.025	0.079	-0.098	0.210	0.315	0.983	-0.026	-0.026
days_since_first_war	-0.025	1.000	0.044	0.098	-0.046	0.041	-0.026	0.082	0.999
faction_id	0.079	0.044	1.000	0.476	-0.552	0.081	0.019	-0.036	0.040
member_id	-0.098	0.098	0.476	1.000	-0.741	0.129	-0.136	-0.065	0.093
member_level	0.210	-0.046	-0.552	-0.741	1.000	0.259	0.268	0.079	-0.041
participated	0.315	0.041	0.081	0.129	0.259	1.000	0.079	0.132	0.046
score	0.983	-0.026	0.019	-0.136	0.268	0.079	1.000	-0.030	-0.027
war_duration_hours	-0.026	0.082	-0.036	-0.065	0.079	0.132	-0.030	1.000	0.096
war_id	-0.026	0.999	0.040	0.093	-0.041	0.046	-0.027	0.096	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	war_id	faction_id	member_id	member_name	member_level	war_start_time	war_duration_hours	attacks	score	participated	days_since_first_war
0	28013	33241	3498240	ValascaS	35	2025-07-11 14:00:00	84.02	15	299.17	True	287
1	28013	33241	3487587	Tom--	46	2025-07-11 14:00:00	84.02	17	236.97	True	287
2	28013	33241	1880691	Schnitzel	100	2025-07-11 14:00:00	84.02	16	218.82	True	287
3	28013	33241	2890346	Volny	81	2025-07-11 14:00:00	84.02	20	214.11	True	287
4	28013	33241	1717276	Travis-	98	2025-07-11 14:00:00	84.02	17	189.54	True	287
5	28013	33241	2479416	Slaterz	100	2025-07-11 14:00:00	84.02	16	187.92	True	287
6	28013	33241	2535063	VanHorn	99	2025-07-11 14:00:00	84.02	17	175.26	True	287
7	28013	33241	2002288	kwartz	100	2025-07-11 14:00:00	84.02	15	163.43	True	287
8	28013	33241	2597200	IndyCision	69	2025-07-11 14:00:00	84.02	19	157.75	True	287
9	28013	33241	2116723	Argozdoc	100	2025-07-11 14:00:00	84.02	13	141.69	True	287

	war_id	faction_id	member_id	member_name	member_level	war_start_time	war_duration_hours	participated	days_since_first_war
52783	20149	52484	3050247	Giellie	30	2024-12-14 18:00:00	76.19	False	78
52784	20149	52484	3418287	Coffee_Frog	43	2024-12-14 18:00:00	76.19	False	78
52785	20149	52484	3427786	NOTAC0P	17	2024-12-14 18:00:00	76.19	False	78
52786	20149	52484	3506203	BigPappaT	21	2024-12-14 18:00:00	76.19	False	78
52787	20149	52484	3506777	BIGSHOW1	25	2024-12-14 18:00:00	76.19	False	78
52788	20149	52484	3512959	BigMoney10	11	2024-12-14 18:00:00	76.19	False	78
52789	20149	52484	3439230	bubbaharris	8	2024-12-14 18:00:00	76.19	False	78
52790	20149	52484	3498488	BCdagoat	20	2024-12-14 18:00:00	76.19	False	78
52791	20149	52484	3462764	devious_nige	45	2024-12-14 18:00:00	76.19	False	78
52792	20149	52484	3348344	MamaDrgn	43	2024-12-14 18:00:00	76.19	False	78

Overview

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample